﻿CREATE TABLE [dbo].[Service] (
    [ServiceID]      INT           IDENTITY (1, 1) NOT NULL,
    [ServerID]       INT           NULL,
    [Name]           VARCHAR (4000) NULL,
    [LogOnAs]        VARCHAR (4000)  NULL,
    [StartMode]      VARCHAR (4000)  NULL,
    [ServiceTypeID]  INT           NULL,
    [ProductVersion] VARCHAR (4000)  NULL,
    [Edition]        VARCHAR (4000)  NULL,
    [Description]    VARCHAR (4000) NULL,
    [Authentication] VARCHAR (4000)  NULL,
    [Port]           INT           NULL,
    [Login]          VARCHAR (4000)  NULL,
    [Password]       VARCHAR (4000)  NULL,
    [Started]        SMALLDATETIME NULL,
    [Collation]      VARCHAR (4000)  NULL,
    CONSTRAINT [PK_Service] PRIMARY KEY CLUSTERED ([ServiceID] ASC),
    CONSTRAINT [FK_ServiceServer] FOREIGN KEY ([ServerID]) REFERENCES [dbo].[Server] ([ServerID])
);



